SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbSTecnicos
AS
SELECT     dbo.Tb_STecnicos.ApellidoyNombre, dbo.vwrSAreasInformaticas.Descripcion AS Area
FROM         dbo.Tb_STecnicos RIGHT OUTER JOIN
                      dbo.vwrSAreasInformaticas ON dbo.Tb_STecnicos.IDAInformatica = dbo.vwrSAreasInformaticas.ID
GO
GRANT SELECT ON  [dbo].[vwbSTecnicos] TO [Informatica]
GRANT SELECT ON  [dbo].[vwbSTecnicos] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwbSTecnicos] TO [Soporte]
GO
